{"text_format":"3","workbook":"xlsx","n_sheets":27,"sheets":["Inicio","Electricity EF","Ciudad","Carretera","Upgrades log","City Parameters","Carretera DB","Common parameters","City Graphs data","Ferroviario Parámetros","Fluvial Parámetros","Fluvial DB","Ferroviario","Fluvial","Rail Graphs Data","Reparto Fuera Horario","Factor Emisión Consumo","Predicción","Resultados","Reducción Distancia","Ferroviario DB","Conducción Eficiente","Cambio Combustible","Road Graphs data","Carretera parámetros","Road EF","Water Graphs data"],"not_rendered":{"charts":15,"images":39,"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Electricity EF","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"hidden":true,"merged":[[8,0,9,1]]}
["Fuente de energía para la generación de electricidad.","Factores de emisión de electricidad (g CO2e por kWh) *"]
["Base de carbón alta",850]
["Fósiles",500]
["Media UE",320]
["Renovable en curso",200]
["Altamente descarbonizado",30]
["No aplica",0]
["Otros",160]
["*La Agencia Internacional de Energía (AIE) compila y publica listas actualizadas anualmente de factores nacionales de emisión de electricidad, y recomendamos que las ciudades lo utilicen como fuente de información. Otras fuentes disponibles se pueden encontrar aquí: https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf"]

{"sheet":"Ciudad","index":2,"n_rows":168,"n_cols":15,"rows_kept":168,"hidden":true,"merged":[[1,1,1,12],[3,3,3,11],[5,3,5,5],[5,7,5,8],[5,9,5,11],[7,3,7,5],[7,7,7,8],[7,9,7,11],[9,3,9,5],[9,7,9,8],[9,9,9,11],[11,3,11,11],[15,1,15,12],[17,2,18,3],[17,5,18,5],[17,7,18,7],[17,9,18,9],[17,11,18,11],[20,2,20,3],[22,2,22,3],[24,2,25,3],[27,1,27,12],[29,2,29,3],[31,2,32,3],[34,2,35,3],[37,2,38,3],[40,2,41,3],[43,2,44,3],[46,1,46,11],[48,2,48,3],[50,2,51,3],[53,2,54,3],[56,2,57,3],[59,2,60,3],[62,2,63,3],[65,1,65,11],[67,2,67,3],[69,2,69,3],[71,2,71,3],[73,2,73,3],[77,1,77,12],[80,2,80,3],[80,5,80,11],[82,2,82,3],[82,5,82,11],[84,2,86,3],[84,5,86,11],[87,2,87,11],[89,2,90,3],[92,2,93,3],[95,2,96,3],[98,2,99,3],[101,2,102,3],[104,1,104,11],[106,2,107,3],[109,2,110,3],[112,2,113,3],[115,1,115,11],[117,2,118,3],[120,2,121,3],[123,2,124,3],[126,1,126,11],[128,2,129,3],[131,2,132,3],[134,2,135,3],[137,1,137,11],[139,2,140,3],[142,2,143,3],[145,2,146,3],[148,1,148,11],[150,2,151,3],[153,2,154,3],[156,2,157,3],[159,1,159,11],[161,2,162,3],[164,2,165,3],[167,2,168,3]]}
[]
[null,"Características de la ciudad"]
[]
[null,null,"Nombre ciudad:"]
[]
[null,null,"Pais:",{"$nulls":4},"Región:"]
[]
[null,null,"Area (km2):",{"$nulls":4},"Longitud:"]
[]
[null,null,"Límites:","Administrative",{"$nulls":3},"Latitud:"]
[]
[null,null,"Clima**:","ej. Af"]
[]
[]
[]
[null,"Parámetros de la ciudad"]
[]
[null,null,"Año:",null,null,2019,2,2020,null,2021,null,2022]
[]
[]
[null,null,"Población (k):",{"$nulls":11},"*Campos en blanco: Opcionales"]
[]
[null,null,"PIB (millones de EEUU $):",{"$nulls":11},"*Campos en amarillo: Obligatorios"]
[]
[null,null,"Ratio estimado de crecimiento de población (%):",{"$nulls":11},"**Deacuerdo a la clasificación climática de Köppen"]
[]
[]
[null,"Vehículo de mercancías pesadas (Peso bruto del vehículo de 3.5 toneladas o más)"]
[]
[null,null,"Nº registrado de  vehículos (k):"]
[]
[null,null,"Tasa de crecimiento anual de vehículos matriculados (%):"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) - Dentro de:"]
[]
[{"$nulls":9},3,null,15]
[null,null,"Carga urbana total (millones de toneladas) - Desde:"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) - Hacia:"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) -A través de:"]
[]
[]
[null,"Vehículo de mercancías ligeras (Preso bruto del vehículo de hasta 3.5 toneladas)"]
[]
[null,null,"Nº registrado de  vehículos (k):"]
[]
[null,null,"Tasa de crecimiento anual de vehículos matriculados (%):"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) - Dentro de:"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) - Desde:"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) - Hacia:"]
[]
[]
[null,null,"Carga urbana total (millones de toneladas) -A través de:"]
[]
[]
[null,"Objetivo de reducción de emisiones totales"]
[]
[null,null,"Transporte aereo(%):"]
[]
[null,null,"Transporte ferroviario (%):"]
[]
[null,null,"Transporte carretero (%):"]
[]
[null,null,"Transporte fluvial (%):"]
[]
[]
[]
[null,"Calidad del aire"]
[null,"Índice de calidad del aire (ICA)"]
[]
[null,null,"Índice numérico:",null,null,567]
[]
[null,null,"Riesgo:",null,null,"Peligroso"]
[]
[null,null,"Declaración de precaución:",null,null,"Todos deben evitar toda actividad física al aire libre."]
[]
[]
[]
[{"$nulls":5},{"$f":"F18","v":2019},{"$f":"G18","v":2},2020,0,2021,0,2022]
[null,null,"\nRango de concentración de PM2.5 [ug / m3]:"]
[]
[]
[null,null,"\nRango de concentración de PM10 [ug / m3]:"]
[]
[]
[null,null,"\nRango de concentración de NO2 [ug / m3]:"]
[]
[]
[null,null,"\nRango de concentración de Ozono [ug / m3]:"]
[]
[]
[null,null,"Número de días que exceden los estándares AQI (días / año):"]
[]
[]
[null,"Partículas finas (PM2.5)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Partículas (PM10)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Concentración media anual [ug / m3]:"]
[]
[]
[null,"Monóxido de carbono (CO)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Concentración media anual [ug / m3]:"]
[]
[]
[null,"Dióxido de nitrógeno (NO2)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Concentración media anual [ug / m3]:"]
[]
[]
[null,"Dióxido de sulfuro (SO2)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Concentración media anual [ug / m3]:"]
[]
[]
[null,"Ozono (O3)"]
[]
[null,null,"Concentración media diaria mínima [ug / m3]:"]
[]
[]
[null,null,"Concentración media diaria máxima [ug / m3]:"]
[]
[]
[null,null,"Concentración media anual [ug / m3]:"]

{"sheet":"Carretera","index":3,"n_rows":43,"n_cols":35,"rows_kept":43,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[22,28,23,33],[22,34,23,39],[25,4,26,12],[25,13,26,24],[25,28,26,33],[25,34,26,39],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40],[40,3,41,40],[42,3,46,40]]}
[]
[]
[{"$nulls":3},"Datos de entrada del transporte por carretera"]
[]
[]
[]
[]
[{"$nulls":4},"Año:",{"$nulls":8},2019,{"$nulls":14},"Tipo de viaje:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Peso bruto del vehículo (t):",{"$nulls":8},"Vehículo ligero (<3.5 t)",{"$nulls":14},"Tipo de mercancía: ",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Factor de carga (%):",{"$nulls":8},24,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Distancia total (milliones km):",{"$nulls":8},0,{"$nulls":14},"Nº vehículos (k):",{"$nulls":5},0]
[]
[]
[{"$nulls":4},"Milliones ton.km:",{"$nulls":8},0,{"$nulls":14},"Años vehículos:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Tipo de combustible:",{"$nulls":8},"E12 gasolina blend",{"$nulls":14},"Unidad combustible:",{"$nulls":5},"litro"]
[]
[]
[{"$nulls":4},"Consumo (l/100 km)*:",{"$nulls":8},0,{"$nulls":14},"Electricidad FE2*, 3*:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Emisiones (Millones de toneladas)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"* Consumo de combustible (litros / 100 km), (galones / 100 km), (kg / 100 km) o (kWh / 100 km), según el tipo de combustible y su unidad respectiva."]
[]
[{"$nulls":3},"2 * Factores de emisión de electricidad (g CO2e por kWh), cuando los usuarios eligen la electricidad como tipo de energía."]
[]
[{"$nulls":3},"3 * La Agencia Internacional de Energía (AIE) compila y publica listas actualizadas anualmente de factores nacionales de emisión de electricidad, y recomendamos que las ciudades lo utilicen como fuente de información. Se pueden encontrar otras fuentes disponibles en https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf."]

{"sheet":"Upgrades log","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"hidden":true}
["2020-03-19","Message when someone selects a vehicle (motorcycle, rickshaw, etc.) and the ef is not known. Spanish version does not include it."]

{"sheet":"City Parameters","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"hidden":true}
["City","Region",null,"Climate",null,"Boundaries"]
["Buenos aires","África",null,"Tropical",null,"Administrativos"]
["Rosario","Asia del Este",null,"Dry",null,"Geográficos"]
["Santa Fe","Europa",null,"Moderate"]
["Bogotá","América Latina & Caribe",null,"Continental"]
["Manizales","Norte de Áfirca, Asia del oeste y mediando este",null,"Polar"]
["Cordoba","Norte América"]
["Metropolitan Area of the Aburrá Valley (AMVA)","Oceania"]
["Kochi","Sur de Asia"]
["Panaji","Sureste de Asia"]
["Shimla"]

{"sheet":"Carretera DB","index":6,"n_rows":1,"n_cols":15,"rows_kept":1,"hidden":true}
["Año","Peso bruto del vehículo (t)","Factor de carga","Distancia total (millones de km)","Milliones ton.km","Tipo de combustible","Unidad de combustible","Consumo (l/100km)","CO2","CO2e","Límites de la ciudad","Tipo de mercancía","Refrigerado","Número de vehículos","Edad de los vehículos"]

{"sheet":"Common parameters","index":7,"n_rows":6,"n_cols":8,"rows_kept":6,"hidden":true,"merged":[[28,0,28,4]]}
["Year","Type of trip flow",null,"Boolean",null,"Off-hour deliveries","Reduction","fuel units"]
[{"$f":"Ciudad!F$18","v":2019},"No aplica",null,"Si",null,"7PM - 6AM",56,"kg"]
[{"$f":"Ciudad!H$18","v":2020},"Dentro de",null,"No",null,"6PM - 10PM",13,"litro"]
[{"$f":"Ciudad!J$18","v":2021},"Desde",{"$nulls":3},"6AM - 7PM",0,"galón"]
[{"$f":"Ciudad!L$18","v":2022},"Hacia",{"$nulls":5},"kWh"]
[null,"A través de"]

{"sheet":"City Graphs data","index":8,"n_rows":18,"n_cols":7,"rows_kept":18,"hidden":true,"merged":[[1,0,3,0],[4,0,6,0],[7,0,9,0],[10,0,12,0]]}
["year",null,{"$f":"Ciudad!$F$18","v":2019},{"$f":"Ciudad!$H$18","v":2020},{"$f":"Ciudad!$J$18","v":2021},{"$f":"Ciudad!$L$18","v":2022}]
["Within","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C2+C3","v":0},{"$f":"D2+D3","v":0},0,0]
["From","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C5+C6","v":0},{"$f":"D5+D6","v":0},{"$f":"E5+E6","v":0},{"$f":"F5+F6","v":0}]
["To","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C8+C9","v":0},{"$f":"D8+D9","v":0},{"$f":"E8+E9","v":0},{"$f":"F8+F9","v":0}]
["Through","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C11+C12","v":0},{"$f":"D11+D12","v":0},{"$f":"E11+E12","v":0},{"$f":"F11+F12","v":0}]
[]
[]
[]
[]
[{"$nulls":6}," "]

{"sheet":"Ferroviario Parámetros","index":9,"n_rows":15,"n_cols":24,"rows_kept":15,"hidden":true}
["Type of fuels","Type of goods","Age of Locomotives","Load Characteristics","Payload capacity Wagon (t)","Emission intensity (g CO2e/tkm)  (Ambient, Diesel)","Emission intensity (g CO2e/tkm) (Refrigerated, Diesel)"," uplift values (Asia)","Emission intensity (g CO2e/tkm)  (Ambient, Petrol[gasoline])","Emission intensity (g CO2e/tkm) (Refrigerated, Petrol[gasoline])","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LPG)","Emission intensity (g CO2e/tkm) (Refrigerated, LPG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, CNG)","Emission intensity (g CO2e/tkm) (Refrigerated, CNG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LNG)","Emission intensity (g CO2e/tkm) (Refrigerated, LNG)","uplift values %(Asia)","kWh/t-km  (Electricity)","kWh/t-km (Electricity)","uplift values %","Load factor (%)"]
["Diésel  (litro)","Voluminosa","De 0 a 5","Promedio / mixto",61,28,0,0,{"$nulls":12},0.0322,null,0,60]
["Electricidad (kWh)","Media","From 5 to 10","Envase",65,25,{"$nulls":14},0.0294,null,null,60]
["Diésel (galón)","Granel","From 10 to 15","Coches",21,60,0,0,{"$nulls":12},0.0693,null,0,50]
[null,"No aplica","Over 15","Productos quimicos",55,24,0,0,{"$nulls":12},0.0277,null,0,85]
[null,null,"No aplica","Carbón y acero",65,19,0,0,{"$nulls":12},0.0215,null,0,100]
[{"$nulls":3},"Materiales de construcción",54,23,0,0,{"$nulls":12},0.0268,null,0,100]
[{"$nulls":3},"Productos manufacturados",54,24,0,0,{"$nulls":12},0.0282,null,0,100]
[{"$nulls":3},"Cereales",63,18,0,0,{"$nulls":12},0.0212,null,0,75]
[{"$nulls":3},"Camión + remolque en tren",63,130,0,0,{"$nulls":12},0,null,0,100]
[{"$nulls":3},"Remolque solo en tren",63,90,0,0,{"$nulls":12},0,null,0,85]
[]
[]
[]
[{"$nulls":3},61]

{"sheet":"Fluvial Parámetros","index":10,"n_rows":12,"n_cols":12,"rows_kept":12,"hidden":true}
["Tipo de combustibel","tipode mercancia","Edad de las embarcaciones","tipo de buque","Carga util","Emision por intesidad(g CO2e/tkm)  (Ambiente, Diesel)","Emision por intesidad(g CO2e/tkm) (Refrigerado, Diesel)","Factor de corrección(Asia)","Emision por intesidad(g CO2e/tkm)  (Ambiente, Petrol[gasoline])","Emision por intesidad(g CO2e/tkm) (Refrigerado, Petrol[gasoline])","Factor de corrección  %(Asia)","factor de carga (%)"]
["Diésel Fluvial (litro)","Voluminoso","0-5","Barcos a motor <80 m [1000T]",477,30,0,0,{"$nulls":3},55]
[null,"Contenedores","5-10","Buques de motor 85-110 m [1000 - 2000T]",1497,19,0,0,{"$nulls":3},52]
[null,"Paletas","10-15","Buques Motos 135 m [2000 - 3000T]",2135,19,0,0,{"$nulls":3},50]
[null,"Masa - limitada","> 15","Convoyes acoplados [163-185 m]",2903,17,0,0,{"$nulls":3},61]
[null,"Volumen limitado","No aplica","Convoy empujado - bote de empuje + 2 barcazas",3000,17,0,0,{"$nulls":3},70]
[null,"No aplica",null,"Convoy empujado - bote de empuje + 4/5 barcazas",8000,10,0,0,1000,null,13,70]
[{"$nulls":3},"Convoy empujado - bote de empuje + 6 barcazas",10000,7.4,0,0,{"$nulls":3},70]
[{"$nulls":3},"Buques cisterna",4195,21,0,0,{"$nulls":3},65]
[{"$nulls":3},"Buques portacontenedores 110m",1410,26,0,0,{"$nulls":3},75]
[{"$nulls":3},"Contenedores 135",3141,20,0,0,{"$nulls":3},75]
[{"$nulls":3},"Buques portacontenedores - convoyes acoplados",2502,20,0,0,{"$nulls":3},68]

{"sheet":"Fluvial DB","index":11,"n_rows":1,"n_cols":14,"rows_kept":1,"hidden":true}
["Año","Peso bruto de la embarcación (t)","Factor de carga","Distancia total (millones de km)","Milliones ton.km","Tipo de combustible","Eficiencia energética","CO2","CO2e","Límites de la ciudad","Tipo de mercancía","Refrigerado","Número de Embarcaciones","Edad de las embarcaciones"]

{"sheet":"Ferroviario","index":12,"n_rows":43,"n_cols":35,"rows_kept":43,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[25,4,26,12],[25,13,26,24],[25,28,26,33],[25,34,26,39],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40],[40,3,41,40],[42,3,46,40]]}
[]
[]
[{"$nulls":3},"Datos de entrada de transporte ferroviario"]
[]
[]
[]
[]
[{"$nulls":4},"Año:",{"$nulls":8},2019,{"$nulls":14},"Tipo de viaje:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Tipo de tren:",{"$nulls":8},"Promedio / mixto",{"$nulls":14},"Tipo de mercancía:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Factor de carga (%):",{"$nulls":8},60,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Distancia total (km):",{"$nulls":8},0,{"$nulls":14},"Nº. De vagones:",{"$nulls":5},20]
[]
[]
[{"$nulls":4},"Milliones ton.km:",{"$nulls":8},0,{"$nulls":14},"Edad locomotora:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Tipo de tracción (unidad):",{"$nulls":8},"Diésel (litro)"]
[]
[]
[{"$nulls":4},"Consumo (l/100 km)*:",{"$nulls":8},0,{"$nulls":14},"Electricidad FE 2*, 3*:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Emisiones (Millones de toneladas)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"* Consumo de combustible (litros / 100 km), (galones / 100 km), (kg / 100 km) o (kWh / 100 km), según el tipo de combustible y su unidad respectiva."]
[]
[{"$nulls":3},"2 * Factores de emisión de electricidad (g CO2e por kWh), cuando los usuarios eligen la electricidad como tipo de energía."]
[]
[{"$nulls":3},"3 * La Agencia Internacional de Energía (AIE) compila y publica listas actualizadas anualmente de factores nacionales de emisión de electricidad, y recomendamos que las ciudades lo utilicen como fuente de información. Se pueden encontrar otras fuentes disponibles en https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf."]

{"sheet":"Fluvial","index":13,"n_rows":39,"n_cols":35,"rows_kept":39,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[25,4,26,12],[25,13,26,24],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40]]}
[]
[]
[{"$nulls":3},"Datos entrada transporte fluvial"]
[]
[]
[]
[]
[{"$nulls":4},"Año:",{"$nulls":8},2019,{"$nulls":14},"Tipo de viaje:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Tipo de buque (peso bruto):",{"$nulls":8},"Barcos a motor <80 m [1000T]",{"$nulls":14},"Tipo de mercancía: ",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Factor de carga (%):",{"$nulls":8},55,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Distancia total (km):",{"$nulls":8},0,{"$nulls":14},"Nº embarcaciones:",{"$nulls":5},0]
[]
[]
[{"$nulls":4},"Milliones ton.km:",{"$nulls":8},0,{"$nulls":14},"Edad embarcaciones:",{"$nulls":5},"No aplica"]
[]
[]
[{"$nulls":4},"Tipo combustible (unidad):",{"$nulls":8},"Diésel Fluvial (litro)"]
[]
[]
[{"$nulls":4},"Consumo (l/100 km)*:",{"$nulls":8},0]
[]
[]
[{"$nulls":4},"Emisiones (Millones toneladas)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"* Consumo de combustible (litros / 100 km), (galones / 100 km), (kg / 100 km) o (kWh / 100 km), según el tipo de combustible y su unidad respectiva."]

{"sheet":"Rail Graphs Data","index":14,"n_rows":22,"n_cols":5,"rows_kept":22,"hidden":true}
["Measurement",{"$f":"Ciudad!$F$18","v":2019},{"$f":"Ciudad!$H$18","v":2020},{"$f":"Ciudad!$J$18","v":2021},{"$f":"Ciudad!$L$18","v":2022}]
["CO2e (million tonnes)",2.9612298293567663E-6,0,0,0]
["Million tonne-km",0.531312,0,0,0]
[]
[]
[]
[null,0]
[null,0]
["Promedio / mixto",0]
["Envase",0]
["Coches",0]
["Productos quimicos",0]
["Carbón y acero",2.14656e-07]
["Materiales de construcción",2.071656e-06]
["Productos manufacturados",1.573600194112E-7]
["Cereales",4.833864e-07]
["Camión + remolque en tren",3.3774298848e-08]
["Remolque solo en tren",3.971110975661376E-10]
[]
["Diésel",5.1718382935676625E-7,{"$f":"B20/SUM(B$20:B$21)","v":0.1746517018806028}]
["Electricidad",2.444046e-06,{"$f":"B21/SUM(B$20:B$21)","v":0.8253482981193971}]
[null,1]

{"sheet":"Reparto Fuera Horario","index":15,"n_rows":33,"n_cols":7,"rows_kept":33,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[25,2,25,4],[30,1,30,6],[31,1,31,6],[32,1,32,6]]}
[]
[null,"Carretera - Evaluación Impacto del reparto fuera de horario "]
[]
[]
[null,null,"Año de referencia:",{"$f":"Ciudad!F18","v":2019}]
[null,null,"Año a predecir:",2050]
[null,null,"Tipo de vehículo:","Camión rígido (7.5 t-12t)"]
[null,null,"Refrigerado:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Tasa crecimiento carretero (%):",{"$f":"Predicción!I6","v":3},null,"*"]
[null,null,"Periodos fuera de horario:","6PM - 10PM",null,"**"]
[]
[]
[{"$nulls":3},"Name",null,"EF (g CO2e/t.km)"]
[null,null,"Combustible referencia:","Diésel puro",null,{"v":240,"d":"240.00"}]
[null,null,"Factor de corrección (Asia, África):",0,null,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Referencia","Pronóstico","Objetivo"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Millones km:",{"v":34,"d":"34.00"},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":85.00273174106188,"d":"85.00"}},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":85.00273174106188,"d":"85.00"}}]
[null,null,"Millones t.km:",{"v":102,"d":"102.00"},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":255.00819522318562,"d":"255.01"}},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":255.00819522318562,"d":"255.01"}}]
[null,null,"Millones toneladas CO2e:",{"v":0.02448,"d":"0.0245"},{"v":0.06120196685356455,"d":"0.0612"},{"v":0.053245711162601156,"d":"0.0532"}]
[null,null,"Reducción de emisiones CO2e (%):",null,null,{"$f":"IF(F25=0,0,(1-F25/E25)*100)","v":13},"***"]
[]
[]
[]
[]
[null,"*La última estimación del Foro Internacional de Transporte (ITF) sugiere que la demanda mundial de transporte de carga crece a 3.1 por ciento y 3.4 por ciento anual hasta 2030 y 2050 respectivamente (ITF Transport Outlook 2019). Cabe señalar que puede ser engañoso depender de datos globales, y se deben buscar datos de buena calidad en el país siempre que sea posible."]
[null,"**Fuente: Holguín-Veras, José & Encarnación, Trilce & Gonzalez-Calderon, Carlos & Winebrake, James & Wang, Cara & Kyle, Sofia & Herazo-Padilla, Nilson & Kalahasthi, Lokesh & Adarme, Wilson & Cantillo, Victor & Yoshizaki, Hugo & Garrido, Rodrigo. (2016). Direct impacts of off-hour deliveries on urban freight emissions. Transportation Research Part D: Transport and Environment. "]
[null,"***La magnitud de las reducciones de emisiones depende de la extensión del cambio del tiempo de entrega. Un estudio en tres ciudades principales de las Américas indica que OHD produce emisiones que son 13 a 56 por ciento más bajas que las producidas por entregas realizadas durante horas regulares en rutas similares. Sin embargo, esto podría no ser aplicable a otras ciudades o regiones.."]

{"sheet":"Factor Emisión Consumo","index":16,"n_rows":46,"n_cols":14,"rows_kept":46,"hidden":true,"merged":[[1,1,1,3],[1,4,1,6],[1,7,2,7],[1,8,1,10],[1,11,1,13]]}
[]
[null,"kg CO2 / kg fuel",null,null,"kg CO2e / kg fuel",null,null,"Density","kg CO2 / l fuel",null,null,"kg CO2e / l fuel"]
[null,"WTT CO2","TTW CO2","WTW CO2","WTT CO2e","TTW CO2e","WTW CO2e",null,"WTT CO2","TTW CO2","WTW CO2","WTT CO2e","TTW CO2e","WTW CO2e"]
["HFO ",{"$f":"D4-C4","v":{"v":0.2678040000000004,"d":"0.27"}},{"v":3.114,"d":"3.11"},{"$f":"1.086*C4","v":{"v":3.3818040000000003,"d":"3.38"}},{"$f":"G4-F4","v":{"v":0.26000000000000023,"d":"0.26"}},3.15,3.41,{"v":0.97,"d":"0.970"},{"$f":"B4*$H4","v":{"v":0.25976988000000034,"d":"0.26"}},{"v":3.02058,"d":"3.02"},{"v":3.28034988,"d":"3.28"},{"v":0.2522000000000002,"d":"0.25"},{"v":3.0555,"d":"3.06"},{"v":3.3077,"d":"3.31"}]
["Diésel Fluvial (litro)",{"v":0.679672,"d":"0.68"},{"v":3.206,"d":"3.21"},{"$f":"1.212*C5","v":{"v":3.885672,"d":"3.89"}},{"v":0.6864687199999997,"d":"0.69"},{"$f":"1.01*C5","v":{"v":3.23806,"d":"3.24"}},{"v":3.9245287199999996,"d":"3.92"},0.735,{"v":0.49955892,"d":"0.50"},{"v":2.35641,"d":"2.36"},{"v":2.85596892,"d":"2.86"},{"v":0.5045545091999998,"d":"0.50"},{"v":2.3799741,"d":"2.38"},{"v":2.8845286091999998,"d":"2.88"}]
["Gasolina pura",0.61,3.06999,3.68,0.62,{"v":3.1,"d":"3.10"},{"v":3.72082788,"d":"3.72"},0.8,0.49,{"v":2.25644265,"d":"2.26"},2.82,{"v":0.5,"d":"0.50"},2.48,{"v":2.73480849,"d":"2.73"}]
["Diésel puro",0.64,{"v":3.1863,"d":"3.19"},3.82,0.65,3.21,{"v":3.8617956,"d":"3.86"},0.845,0.53,{"v":2.6924235,"d":"2.69"},3.18,0.54,2.67,{"v":3.26321728,"d":"3.26"}]
["Biodiésel B100"," "," "," "," "," ",{"v":2.484888,"d":"2.48"},0.885," "," "," "," "," ",{"v":2.19912588,"d":"2.20"}]
["B10 diésel blend"," "," "," "," "," ",{"v":3.72410484,"d":"3.72"}," "," "," "," "," "," ",{"v":3.15680814,"d":"3.16"}]
["B25 blend"," "," ",0," "," ",{"v":3.5175687,"d":"3.52"},null," "," ",0," "," ",{"v":2.99719443,"d":"3.0"}]
["Bioetanol E100"," "," ",0," "," ",{"v":1.5687,"d":"1.57"},0.7915," "," ",0," "," ",{"v":1.24162605,"d":"1.24"}]
["E12 gasolina blend"," "," ",0," "," ",{"v":3.46257253,"d":"3.46"}," "," "," ",0," "," ",{"v":2.5556266,"d":"2.56"}]
["E27 blend"," "," ",0," "," ",{"v":3.13975335,"d":"3.14"}," "," "," ",0," "," ",{"v":2.33164923,"d":"2.33"}]
["GLP",0.36,3.07,3.43,0.36,{"v":3.1,"d":"3.10"},3.46,{"v":0.55,"d":"0.550"},{"v":0.2,"d":"0.20"},1.69,1.88,{"v":0.2,"d":"0.20"},{"v":1.7,"d":"1.70"},{"v":1.9,"d":"1.90"}]
["GNC",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0.39,2.68,3.07,{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["GNL",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0.94,2.68,3.62," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Biometano",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0.49,{"v":0,"d":"0.00"},0.49," ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Bio GNL",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},1.04,{"v":0,"d":"0.00"},1.04,{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Diésel Fluvial",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"$f":"I5/$D$34","v":{"v":0.13215844444444447,"d":"0.13"}},{"v":0.6233888888888889,"d":"0.62"},{"v":0.7555473333333333,"d":"0.76"},{"v":0.13348002888888882,"d":"0.13"},{"v":0.6296227777777779,"d":"0.63"},{"v":0.7631028066666666,"d":"0.76"}]
["Gasolina pura",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,0.13,0.6,0.75,0.13,0.66,0.72]
["Diésel puro",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,0.14,0.71,0.84,0.14,0.71,0.86]
["Biodiésel B100",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.58]
["B10 diésel blend",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.84]
["B25 blend",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.79]
["Bioetanol E100",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.33]
["E12 gasolina blend",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.68]
["E27 blend",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},{"$nulls":3},0,null,0,0.62]
["LPG",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,0.05,0.45,0.5,0.05,0.45,0.5]
[]
[]
[]
[]
[null,null,"litro","Galón"]
[null,"Conversion",1,3.78]
[]
[]
[null,"Pure diesel (national value)"]
[null,"Biodiesel B100 (European value)"]
[null,"Standard B10 diesel blend (calculado)"]
[null,"B25 blend (calculado)"]
[null,"Pure gasoline (national value)"]
[null,"Bioethanol E100 (European value)"]
[null,"Standard E12 gasoline blend"]
[null,"E27 blend (calculado)"]
[null,"Version herramienta Ingles"]
[null,"sin usar"]

{"sheet":"Predicción","index":17,"n_rows":27,"n_cols":10,"rows_kept":27,"hidden":true,"merged":[[1,1,2,11],[5,2,5,3],[5,6,5,7],[8,7,8,9],[9,3,10,5],[14,1,15,11],[17,2,17,4],[17,5,17,6],[17,7,17,10],[18,3,18,4],[18,5,18,6],[18,7,18,10],[19,3,19,4],[19,5,19,6],[19,7,19,10],[20,3,20,4],[20,5,20,6],[20,7,20,10],[21,3,21,4],[21,5,21,6],[21,7,21,10],[22,3,22,4],[22,5,22,6],[22,7,22,10],[23,3,23,4],[23,5,23,6],[23,7,23,10],[26,1,27,11]]}
[]
[null,"Evaluación del impacto"]
[]
[]
[]
[null,null,"Año referencia:",null,{"$f":"Ciudad!F18","v":2019},null,"Incremento transporte (%):",null,3,"*"]
[]
[]
[{"$nulls":6},"Año referencia","Predicción"]
[{"$nulls":3},"Transporte carga carretera (CO2e millones  toneladas)",null,null,{"$f":"E6","v":2019},2025,2030,2050]
[{"$nulls":6},0.022805887750400003,{"$f":"$G$11*(1+$I$6/100)^($H$10-$G$10)","v":0.02723142264274771},{"$f":"$G$11*(1+$I$6/100)^($I$10-$G$10)","v":0.03156868227604341},{"$f":"$G$11*(1+$I$6/100)^($J$10-$G$10)","v":0.05701655172247119}]
[]
[]
[]
[null,"Evaluación de las acciones"]
[]
[]
[null,null,"Medida",null,null,"Tipo",null,"Descripción"]
[{"$nulls":3},"Cambio de combustible",null,"Mejorar",null,"Esto incluye tecnologías para promover la alta eficiencia y los combustibles alternativos, como los biocombustibles, bio GNC, así como bio GNL, etc."]
[{"$nulls":3},"Reducción de la distancia",null,"Evitar",null,"\nEsto implica la reducción de los kilómetros recorridos del vehículo de un tipo específico de vehículo."]
[{"$nulls":3},"Increase load factor",null,"Improve",null,"Increase vehicles efficiency utilization of an specific type of vehicle"]
[{"$nulls":3},"Acces restriction (type vehicle)",null,"Shift",null,"Replace a percentage of a type of vehicle with smaller ones"]
[{"$nulls":3},"Conducción eficiente",null,"Mejorar",null,"Esto implica capacitar a los conductores para conducir de manera ecológica a fin de ahorrar combustible y reducir las emisiones."]
[{"$nulls":3},"Entregas fuera de horario",null,"Mejorar",null,"También conocido como entregas “fuera de horario”, esto se enfoca en cambiar las entregas de carga del período pico al período fuera de hora."]
[]
[]
[null,"\n* La última estimación del Foro Internacional de Transporte (ITF) sugiere que la demanda global de transporte de carga crece a 3.1 por ciento y 3.4 por ciento anual hasta 2030 y 2050 respectivamente (ITF Transport Outlook 2019). Debe tenerse en cuenta que puede ser engañoso confiar en valores globales. Se deben buscar datos globales y de buena calidad en el país siempre que sea posible."]

{"sheet":"Resultados","index":18,"n_rows":8,"n_cols":10,"rows_kept":8,"hidden":true,"merged":[[3,8,3,10],[4,9,4,10],[5,9,5,10],[6,2,6,3],[6,9,6,10]]}
[]
[]
[]
[{"$nulls":3},"Ciudad:",{"$f":"Ciudad!D4","v":0},{"$nulls":3},"CO2e (millones toneladas) "]
[{"$nulls":3},"Pais:",{"$f":"Ciudad!D6","v":0},{"$nulls":3},"Carretera",{"$f":"'Road Graphs data'!$B$2","v":0.022805887750400003}]
[{"$nulls":3},"Area (km2):",{"$f":"Ciudad!D8","v":0},{"$nulls":3},"Ferroviario",{"$f":"'Rail Graphs Data'!B2","v":2.9612298293567663E-6}]
[null,null,"Población (k):",null,{"$f":"Ciudad!F21","v":0},{"$nulls":3},"Fluvial",{"$f":"'Water Graphs data'!B2","v":0.41431352051014}]
[{"$nulls":3},"PIB (millones US$):",{"$f":"Ciudad!F23","v":0}]

{"sheet":"Reducción Distancia","index":19,"n_rows":29,"n_cols":6,"rows_kept":29,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[12,3,12,4],[13,3,13,4],[24,2,24,4],[28,1,28,6]]}
[]
[null,"Carretera - Evaluación del Impacto de reducir la distancia"]
[]
[]
[null,null,"Año de referencia:",{"$f":"Ciudad!F18","v":2019}]
[null,null,"Año a predecir:",2050]
[null,null,"Tipo de vehículo:","Camión rígido (7.5 t-12t)"]
[null,null,"Refrigerado:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Tasa crecimiento carretero (%):",{"$f":"Predicción!I6","v":3},null,"*"]
[null,null,"Tasa reducción distancia (%):",23]
[]
[{"$nulls":3},"Nombre",null,"FE (g CO2e/t.km)"]
[null,null,"Combustible referencia:","Diésel puro",null,{"v":240,"d":"240.00"}]
[null,null,"Factor de corrección (Asia, África):",0,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Referencia","Pronóstico","Objetivo"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Millones km:",{"v":34,"d":"34.00"},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":85.00273174106188,"d":"85.00"}},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)*(1-(D11/100))","v":{"v":65.45210344061765,"d":"65.45"}}]
[null,null,"Millones t.km:",{"v":102,"d":"102.00"},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":255.00819522318562,"d":"255.01"}},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)*(1-(D11/100))","v":{"v":196.35631032185293,"d":"196.36"}}]
[null,null,"Millones toneladas CO2e:",{"v":0.02448,"d":"0.0245"},{"v":0.06120196685356455,"d":"0.0612"},{"v":0.0471255144772447,"d":"0.0471"}]
[null,null,"Reducción de emisiones CO2e (%):",null,null,{"$f":"IF(F24=0,0,(1-F24/E24)*100)","v":23}]
[]
[]
[]
[null,"* La última estimación del Foro Internacional de Transporte (ITF) sugiere que la demanda global de transporte de carga crece a 3.1 por ciento y 3.4 por ciento anual hasta 2030 y 2050 respectivamente (ITF Transport Outlook 2019). Cabe señalar que puede ser engañoso depender de datos globales, y se deben buscar datos de buena calidad en el país siempre que sea posible."]

{"sheet":"Ferroviario DB","index":20,"n_rows":1,"n_cols":14,"rows_kept":1,"hidden":true}
["Año","Tipo de tren","Factor de carga","Distancia total (km)","Millones de ton.km","Tipo de tracción","Consumo de combustible","CO2","CO2e","Límites ciudad","Tipo de mercancía","Refrigerado","Número de vagones","Edad de las locomotoras"]

{"sheet":"Conducción Eficiente","index":21,"n_rows":32,"n_cols":6,"rows_kept":32,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[25,2,25,4],[30,1,30,6],[31,1,31,6]]}
[]
[null,"Carretera - Conducción Eficiente Evaluación del Impacto"]
[]
[]
[null,null,"Año de referencia:",{"$f":"Ciudad!F18","v":2019}]
[null,null,"Año a predecir:",2050]
[null,null,"Tipo de vehículo:","Camión rígido (7.5 t-12t)"]
[null,null,"Refrigerado:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Tasa crecimiento carretero (%):",{"$f":"Predicción!I6","v":3},null,"*"]
[null,null,"Tasa reducción conduccion eficiente (%):",10,null,"**"]
[]
[{"$nulls":3},"Nombre",null,"FE (gCO2e/t.km)"]
[null,null,"Combustible referencia:","Diésel puro",null,{"v":240,"d":"240.00"}]
[null,null,"Factor de corrección (Asia, África):",{"v":1,"d":"1.00"},null,0]
[null,null,"Factor de corrección (Asia, África):",0,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Referencia","Pronóstico","Objetivo"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Millones km:",{"v":34,"d":"34.00"},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":85.00273174106188,"d":"85.00"}},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":85.00273174106188,"d":"85.00"}}]
[null,null,"Millones t.km:",{"v":102,"d":"102.00"},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":255.00819522318562,"d":"255.01"}},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":255.00819522318562,"d":"255.01"}}]
[null,null,"Millones toneladas CO2e:",{"v":0.02448,"d":"0.0245"},{"v":0.06120196685356455,"d":"0.0612"},{"v":0.055081770168208095,"d":"0.0551"}]
[null,null,"Reducción de emisiones CO2e (%):",null,null,{"$f":"IF(F25=0,0,(1-F25/E25)*100)","v":{"v":9.999999999999998,"d":"10"}}]
[]
[]
[]
[]
[null,"*La última estimación del Foro Internacional de Transporte (ITF) sugiere que la demanda mundial de transporte de carga crece a 3.1 por ciento y 3.4 por ciento anual hasta 2030 y 2050 respectivamente (ITF Transport Outlook 2019). Cabe señalar que puede ser engañoso depender de datos globales, y se deben buscar datos de buena calidad en el país siempre que sea posible."]
[null,"**El valor predeterminado es 10 por ciento; Fuente: \"ITS4CV\" - ITS para vehículos comerciales. Estudio del alcance de los sistemas inteligentes de transporte para reducir las emisiones de CO2 y aumentar la seguridad de los vehículos pesados, autobuses y autocares. (2016) Recuperado de http://erticonetwork.com/wp-content/uploads/2016/09/ITS4CV-Report-final-2016-09-09.pdf"]

{"sheet":"Cambio Combustible","index":22,"n_rows":33,"n_cols":9,"rows_kept":33,"hidden":true,"merged":[[1,1,2,9],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[12,3,12,4],[12,6,12,7],[13,3,13,4],[13,6,13,7],[14,3,14,4],[14,6,14,7],[24,2,24,4],[29,1,30,9],[31,1,31,9],[32,1,34,9]]}
[]
[null,"Carretera - Evaluación del Impacto de cambiar de tecnología de combustible"]
[]
[]
[null,null,"Año de referencia:",{"$f":"Ciudad!F18","v":2019}]
[null,null,"Año a predecir:",2050]
[null,null,"Tipo de vehículo:","Camión rígido (7.5 t-12t)"]
[null,null,"Refrigerado:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Tasa crecimiento carretero (%):",{"$f":"Predicción!I6","v":3},null,"*"]
[]
[]
[{"$nulls":3},"Tipo de combustible",null,"FE (gCO2e/t.km)*2","Fuente generación  electricidad",null,"FE(gCO2e/kWh)*3"]
[null,null,"Combustible referencia:","Diésel puro",null,240,"Base de carbón alta",null,850]
[null,null,"Combustible a usar:","GNC",null,220,"Altamente descarbonizado",null,30]
[null,null,"Factor corrección (Asia, África):",0,"%"]
[]
[]
[]
[{"$nulls":3},"Referencia","Pronóstico","Objetivo"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Millones km:",{"v":34,"d":"34.00"},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":85.00273174106188,"d":"85.00"}},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":85.00273174106188,"d":"85.00"}}]
[null,null,"Millones t.km:",{"v":102,"d":"102.00"},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":255.00819522318562,"d":"255.01"}},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":255.00819522318562,"d":"255.01"}}]
[null,null,"Millones toneladas CO2e:",{"v":0.02448,"d":"0.0245"},{"v":0.06120196685356455,"d":"0.0612"},{"v":0.05610180294910083,"d":"0.0561"}]
[null,null,"Reducción de emisiones CO2e (%):",null,null,{"$f":"IF(F24=0,0,(1-F24/E24)*100)","v":{"v":8.333333333333337,"d":"8"}}]
[]
[]
[]
[]
[null,"** La última estimación del Foro Internacional de Transporte (ITF) sugiere que la demanda global de transporte de carga crece a 3.1 por ciento y 3.4 por ciento anual hasta 2030 y 2050 respectivamente (ITF Transport Outlook 2019). Cabe señalar que puede ser engañoso depender de datos globales, y se deben buscar datos de buena calidad en el país siempre que sea posible."]
[]
[null,"*2 Se refiere al valor de kWh / t-km cuando los usuarios eligen la electricidad como tipo de energía."]
[null,"*3Factores de emisión de electricidad (g CO2e por kWh) * cuando los usuarios eligen la electricidad como tipo de energía; La Agencia Internacional de Energía (AIE) compila y publica listas actualizadas anualmente de factores nacionales de emisión de electricidad, y recomendamos que las ciudades lo utilicen como fuente de información. Se pueden encontrar otras fuentes disponibles en https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf"]

{"sheet":"Road Graphs data","index":23,"n_rows":35,"n_cols":5,"rows_kept":35,"hidden":true}
["Measurement",{"$f":"Ciudad!$F$18","v":2019},{"$f":"Ciudad!$H$18","v":2020},{"$f":"Ciudad!$J$18","v":2021},{"$f":"Ciudad!$L$18","v":2022}]
["CO2e (million tonnes)",0.022805887750400003,0,0,0]
["Million tonne-km",163.62,0,0,0]
[]
[]
[null,"Number"]
["Carrito / carro no motorizado",0]
["Bicicleta / bicicleta de carga",0]
["Rickshaw motorizado / tuk tuk",0]
["Motocicleta (2 ruedas)",0]
["Tempo",0]
["Vehículo ligero (<3.5 t)",0.0205869]
["Camión rígido (3.5 t - 7.5 t))",0]
["Camión rígido (7.5 t-12t)",2.2189877504000003E-3]
["Camión rígido (12t-20t)",0]
["Camión rígido (> 20t)",0]
["Camiones y Remolques (> 20t)",0]
[null,0]
[]
["Gasolina pura",0,{"$f":"B20/SUM(B$20:B$27)","v":0}]
["Diésel puro",2.2189877504000003E-3,{"$f":"B21/SUM(B$20:B$27)","v":0.11890797083686537}]
["Electricidad",0,0]
["Biodiésel B100",0,0]
["B10 diésel blend",0,0]
["B25 blend",0.016442400000000003,0.8810920291631346]
["Bioetanol E100",0,0]
["E12 gasolina blend",0,0]
["E27 blend",0,0]
["GLP",0]
["GNC",0.0041445]
["GNL",0]
["Biometano",0]
["Bio GNL",0]
[]
[null,{"$f":"SUM(B20:B25)","v":0.018661387750400004}]

{"sheet":"Carretera parámetros","index":24,"n_rows":33,"n_cols":23,"rows_kept":33,"hidden":true}
["Tipos de combustibles","Type of goods","Age of vehicles","Tipos de vehículos","Carga útil (toneladas)","FE por intensidad (g CO2e/ tkm) (Ambientee, Diésel)","FE por intensidad (g CO2e/ tkm)  (Refrigerado, Diesel)"," Factor de corrección (Asia)","FE por intensidad (g CO2e/ tkm)   (Ambiente, Petrol[gasoline])","FE por intensidad (g CO2e/ tkm)  (Refrigerado, Petrol[gasoline])","Factor de corrección %(Asia)","FE por intensidad (g CO2e/ tkm)   (Ambiente, LPG)","FE por intensidad (g CO2e/ tkm)  (Refrigerado, LPG)","Factor de corrección %(Asia)","FE por intensidad (g CO2e/ tkm)   (Ambiente, CNG)","FE por intensidad (g CO2e/ tkm)  (Refrigerado, CNG)","Factor de corrección %(Asia)","FE por intensidad (g CO2e/ tkm)   (Ambiente, LNG)","FE por intensidad (g CO2e/ tkm)  (Refrigerado, LNG)","Factor de corrección %(Asia)","Emission intensity (kWh/tkm)  (Ambiente, electricity)","Emission intensity (kWh/tkm) (Refrigerado, electricity)","Factor de corrección %(Asia)"]
["HFO (litres)","Volume goods","From 0 to 5","Carrito / carro no motorizado",0.5,0,0,0]
["MDO (litres)","Average goods","From 5 to 10","Bicicleta / bicicleta de carga",0.5,0,0,0]
["Gasoline (litres)","Bulk goods","From 10 to 15","Rickshaw motorizado / tuk tuk",0.5,0,0,0]
["Aviation fuel (litres)","Not applicable","Over 15","Motocicleta (2 ruedas)",0.5,0,0,0]
["Diesel (litres)",null,"Not applicable","Tempo",0.75,0,0,13]
["LPG (litres)",null,null,"Vehículo ligero (<3.5 t)",1.3,680,780,13,1000,1150,13,660,760,13,620,710,13,{"$nulls":3},1.1,null,13]
["CNG (kg)",null,null,"Camión rígido (3.5 t - 7.5 t))",2.3,370,415,22,{"$nulls":6},360,405,22,{"$nulls":3},0.5,null,22]
["LNG (kg)",null,null,"Camión rígido (7.5 t-12t)",5,240,270,22,{"$nulls":6},220,250,22,{"$nulls":3},0.4,null,22]
["HFO (gallons)",null,null,"Camión rígido (12t-20t)",8.4,150,170,22,{"$nulls":6},150,170,22,180,200,22]
["MDO (gallons)",null,null,"Camión rígido (> 20t)",15.3,120,145,22,{"$nulls":6},120,145,22,140,170,22]
["Gasoline (gallons)",null,null,"Camiones y Remolques (> 20t)",18.4,90,100,22,{"$nulls":6},90,100,22,90,100,22]
["Diesel (gallons)"]
["LPG (gallons)"]
["Biomethane (kg)"]
["Bio LNG  (kg)"]
[]
[]
["Evaluación del impacto cambio combustible","Evaluación impacto otro tipo"]
["Gasolina pura","Diésel puro"]
["Diésel puro","GNC"]
["Electricidad","GLP"]
["Biodiésel B100","GNC"]
["B10 diésel blend","Gasolina pura"]
["B25 blend","Biometano"]
["Bioetanol E100","Bio GNL"]
["E12 gasolina blend"]
["E27 blend"]
["GLP"]
["GNC"]
["GNL"]
["Biometano"]
["Bio GNL"]

{"sheet":"Road EF","index":25,"n_rows":67,"n_cols":5,"rows_kept":67,"hidden":true}
["Type of fuel","Type of road vehicles"," (g CO2e/tkm)  (Ambient)","(g CO2e/tkm) (Refrigerated)"," uplift values (Asia)"]
["Diésel puro","Carrito / carro no motorizado",0,0,0]
["Diésel puro","Bicicleta / bicicleta de carga",0,0,0]
["Diésel puro","Rickshaw motorizado / tuk tuk",0,0,0]
["Diésel puro","Motocicleta (2 ruedas)",0,0,0]
["Diésel puro","Tempo",0,0,13]
["Diésel puro","Vehículo ligero (<3.5 t)",680,780,13]
["Diésel puro","Camión rígido (3.5 t - 7.5 t))",370,415,22]
["Diésel puro","Camión rígido (7.5 t-12t)",240,270,22]
["Diésel puro","Camión rígido (12t-20t)",150,170,22]
["Diésel puro","Camión rígido (> 20t)",120,145,22]
["Diésel puro","Camiones y Remolques (> 20t)",90,100,22]
["Gasolina pura","Carrito / carro no motorizado",0,0,0]
["Gasolina pura","Bicicleta / bicicleta de carga",0,0,0]
["Gasolina pura","Rickshaw motorizado / tuk tuk",0,0,0]
["Gasolina pura","Motocicleta (2 ruedas)",0,0,0]
["Gasolina pura","Tempo",0,0,0]
["Gasolina pura","Vehículo ligero (<3.5 t)",1000,1150,13]
["Gasolina pura","Camión rígido (3.5 t - 7.5 t))",0,0,0]
["Gasolina pura","Camión rígido (7.5 t-12t)",0,0,0]
["Gasolina pura","Camión rígido (12t-20t)",0,0,0]
["Gasolina pura","Camión rígido (> 20t)",0,0,0]
["Gasolina pura","Camiones y Remolques (> 20t)",0,0,0]
["GLP","Carrito / carro no motorizado",0,0,0]
["GLP","Bicicleta / bicicleta de carga",0,0,0]
["GLP","Rickshaw motorizado / tuk tuk",0,0,0]
["GLP","Motocicleta (2 ruedas)",0,0,0]
["GLP","Tempo",0,0,0]
["GLP","Vehículo ligero (<3.5 t)",660,760,13]
["GLP","Camión rígido (3.5 t - 7.5 t))",0,0,0]
["GLP","Camión rígido (7.5 t-12t)",0,0,0]
["GLP","Camión rígido (12t-20t)",0,0,0]
["GLP","Camión rígido (> 20t)",0,0,0]
["GLP","Camiones y Remolques (> 20t)",0,0,0]
["GNC","Carrito / carro no motorizado",0,0,0]
["GNC","Bicicleta / bicicleta de carga",0,0,0]
["GNC","Rickshaw motorizado / tuk tuk",0,0,0]
["GNC","Motocicleta (2 ruedas)",0,0,0]
["GNC","Tempo",0,0,0]
["GNC","Vehículo ligero (<3.5 t)",620,710,13]
["GNC","Camión rígido (3.5 t - 7.5 t))",360,405,22]
["GNC","Camión rígido (7.5 t-12t)",220,250,22]
["GNC","Camión rígido (12t-20t)",150,170,22]
["GNC","Camión rígido (> 20t)",120,145,22]
["GNC","Camiones y Remolques (> 20t)",90,100,22]
["GNL","Carrito / carro no motorizado",0,0,0]
["GNL","Bicicleta / bicicleta de carga",0,0,0]
["GNL","Rickshaw motorizado / tuk tuk",0,0,0]
["GNL","Motocicleta (2 ruedas)",0,0,0]
["GNL","Tempo",0,0,0]
["GNL","Vehículo ligero (<3.5 t)",0,0,0]
["GNL","Camión rígido (3.5 t - 7.5 t))",0,0,0]
["GNL","Camión rígido (7.5 t-12t)",0,0,0]
["GNL","Camión rígido (12t-20t)",180,200,22]
["GNL","Camión rígido (> 20t)",140,170,22]
["GNL","Camiones y Remolques (> 20t)",90,100,22]
["Electricidad","Carrito / carro no motorizado",0,0,0]
["Electricidad","Bicicleta / bicicleta de carga",0,0,0]
["Electricidad","Rickshaw motorizado / tuk tuk",0,0,0]
["Electricidad","Motocicleta (2 ruedas)",0,0,0]
["Electricidad","Tempo",0,0,0]
["Electricidad","Vehículo ligero (<3.5 t)",1.1,0,0]
["Electricidad","Camión rígido (3.5 t - 7.5 t))",0.5,0,0]
["Electricidad","Camión rígido (7.5 t-12t)",0.4,0,0]
["Electricidad","Camión rígido (12t-20t)",0,0,0]
["Electricidad","Camión rígido (> 20t)",0,0,0]
["Electricidad","Camiones y Remolques (> 20t)",0,0,0]

{"sheet":"Water Graphs data","index":26,"n_rows":21,"n_cols":20,"rows_kept":21,"hidden":true}
["Measurement",{"$f":"Ciudad!F18","v":2019},{"$f":"Ciudad!H18","v":2020},{"$f":"Ciudad!J18","v":2021},{"$f":"Ciudad!L18","v":2022}]
["CO2e (million tonnes)",0.41431352051014,0,0,0,{"$nulls":14},8]
["Million tonne-km",0.06912812,0,0,0]
[]
[]
[]
["Barcos a motor <80 m [1000T]",0.41431249697039996]
["Buques de motor 85-110 m [1000 - 2000T]",0]
["Buques Motos 135 m [2000 - 3000T]",0]
["Convoyes acoplados [163-185 m]",1.02353974E-6]
["Convoy empujado - bote de empuje + 2 barcazas",0]
["Convoy empujado - bote de empuje + 4/5 barcazas",0]
["Convoy empujado - bote de empuje + 6 barcazas",0]
["Buques cisterna",0]
["Buques portacontenedores 110m",0]
["Contenedores 135",0]
["Buques portacontenedores - convoyes acoplados",0]
[]
[]
["Diésel",0.41431352051014]
["Otros",0]